﻿namespace PersonnelStatistics.DAL
{
    /// <summary>
    /// 数据库选项
    /// </summary>
    public static class MyDbContextOptions
    {
        /// <summary>
        /// 数据库地址
        /// </summary>
        public static string DataSource { get; set; } = "www.severa-market.com,10270";

        /// <summary>
        /// 数据库名称
        /// </summary>
        public static string DbName { get; set; } = "test";

        /// <summary>
        /// 数据库登录帐号
        /// </summary>
        public static string DbAccount { get; set; } = "cl";
        /// <summary>
        /// 数据库密码
        /// </summary>
        public static string Password { get; set; } = "801014";

    }
}

//INSERT INTO [dbo].[Table] ([Id], [姓名], [性别], [年龄], [学历], [部门], [职位], [工资], [政治面貌], [婚姻], [身份证], [住址], [电话], [入职时间], [离职时间], [备用联系人], [联系人电话], [照片]) VALUES (0, N'刘德华', N'男', 20, 大学, N'生产部',N'主管', 3000,N'党员',N'未婚','432522201011201856', N'广东省深圳市福田区', '13318652233', '2020/10/20', NULL, N'爸爸', '18817589988', <SQLVARIANT>)
